﻿CREATE TABLE [dbo].[Finance_Record] (
    [Id]          INT             IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [CompanyId]   INT             NULL,
    [CompanyName] NVARCHAR (50)   NULL,
    [SYXJ]        DECIMAL (18, 2) NULL,
    [SYYH]        DECIMAL (18, 2) NULL,
    [YYXJ]        DECIMAL (18, 2) NULL,
    [YYYH]        DECIMAL (18, 2) NULL,
    [ZHYE]        DECIMAL (18, 2) NULL,
    [JKHJ]        DECIMAL (18, 2) NULL,
    [ZJHJ]        DECIMAL (18, 2) NULL,
    [YYXJPZ]      DECIMAL (18, 2) NULL,
    [YYYHPZ]      DECIMAL (18, 2) NULL,
    [CE]          DECIMAL (18, 2) NULL,
    [YSHJ]        DECIMAL (18, 2) NULL,
    [YFHJ]        DECIMAL (18, 2) NULL,
    [XZML]        DECIMAL (18, 2) NULL,
    [XFML]        DECIMAL (18, 2) NULL,
    [XZYS]        DECIMAL (18, 2) NULL,
    [XZYF]        DECIMAL (18, 2) NULL,
    [CDJE]        DECIMAL (18, 2) NULL,
    [WKSR]        DECIMAL (18, 2) NULL,
    [FYLX]        DECIMAL (18, 2) NULL,
    [CreateDate]  DATETIME        NULL,
    [CreateUser]  NVARCHAR (50)   NULL,
    CONSTRAINT [PK_Finance_Record] PRIMARY KEY CLUSTERED ([Id] ASC)
);

